From 3084552fa59c21816365a90843284c05093781ea Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 13 Aug 2026 17:14:05 +0000 Subject: [PATCH] Check NON_BREC_SIGHTING_SOURCES against departdate only when necessary --- db/schemas/lib/triggers/create/biography_data.m4 | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/db/schemas/lib/triggers/create/biography_data.m4 b/db/schemas/lib/triggers/create/biography_data.m4 index e4b801c..f6c7935 100644 --- a/db/schemas/lib/triggers/create/biography_data.m4 +++ b/db/schemas/lib/triggers/create/biography_data.m4 @@ -510,7 +510,7 @@ CREATE OR REPLACE FUNCTION biography_data_func () END IF; -- Cannot have a watch period after study of the individual has ceased. - IF NEW.departdate <> OLD.departdate THEN + IF NEW.departdate < OLD.departdate THEN SELECT watches.wid, watches.commid, watches.date, watches.type INTO a_wid , a_commid , a_date , a_type FROM watches -- 2.34.1